Important Notice

Important: Note from this point forward all quizzes are using only the Orders table with NO JOINed tables. Please open up a new workbook and just use the Orders table for the remaining quizzes

Task Description:

Tasks to complete:

Task List:

Create a new workspace using only the Orders table. None of the JOINed tables we saw earlier.

Open a blank sheet where we can begin creating our visualization.

Drag Shipping Cost to the Rows and Profit to the Columns.

Drag Category to Color in the Marks table.

Drag Market to the Shape in the Marks table.

Quiz 1 below.

Drag Category and Market off the Marks table.

Drag Row ID to the Marks table.

Quiz 2 below.

Notice how the aggregations can sometimes assist in our ability to draw insights, but other times having a point for every row in the dataset might be better.

Task Feedback:

Nice job!

SOLUTION:

APAC Technology had the largest Profit.
Canada Furniture had the smallest Profit.
The relationship between profit and shipping costs appears to be positive and strong.
Furniture in the US had shipping costs approximately 60K greater than Profit.

SOLUTION:

It is hard to tell what type of relationship exists between Profit and Shipping Cost.

Important Notice

Important: Note from this point forward all quizzes are using only the Orders table with **NO JOINed tables. ** Please open up a new workbook and just use the Orders table for the remaining quizzes

Task Description:

Task Feedback:

Important: Note from this point forward all quizzes are using only the Orders table with NO JOINed tables. Please open up a new workbook and just use the Orders table for the remaining quizzes